Passed
Pull Request — master (#56)
by
unknown
03:10 queued 01:29
created

Ingestion1620379228495.up   A

Complexity

Conditions 1

Size

Total Lines 5
Code Lines 5

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 5
dl 0
loc 5
rs 10
c 0
b 0
f 0
1
import {MigrationInterface, QueryRunner} from "typeorm";
2
3
export class Ingestion1620379228495 implements MigrationInterface {
4
    name = 'Ingestion1620379228495'
5
6
    public async up(queryRunner: QueryRunner): Promise<void> {
7
        await queryRunner.query(`CREATE TYPE "ingestion_state_enum" AS ENUM('init', 'upload_started', 'upload_cancelled', 'upload_finished', 'failed')`);
8
        await queryRunner.query(`CREATE TABLE "ingestion" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "state" "ingestion_state_enum" NOT NULL DEFAULT 'init', "schoolId" uuid NOT NULL, CONSTRAINT "PK_c318c071e868a0a37153cabf606" PRIMARY KEY ("id"))`);
9
        await queryRunner.query(`ALTER TABLE "ingestion" ADD CONSTRAINT "FK_bedba27d2f82d30b329ca7248f1" FOREIGN KEY ("schoolId") REFERENCES "school"("id") ON DELETE CASCADE ON UPDATE NO ACTION`);
10
    }
11
12
    public async down(queryRunner: QueryRunner): Promise<void> {
13
        await queryRunner.query(`ALTER TABLE "ingestion" DROP CONSTRAINT "FK_bedba27d2f82d30b329ca7248f1"`);
14
        await queryRunner.query(`DROP TABLE "ingestion"`);
15
        await queryRunner.query(`DROP TYPE "ingestion_state_enum"`);
16
    }
17
18
}
19